<%@page import="java.text.DecimalFormat"%>
<%@page import="org.apache.commons.lang.StringUtils"%>
<%@page import="org.apache.commons.lang.time.DateFormatUtils"%>
<%@page import="org.springframework.util.CollectionUtils"%>
<%@page import="java.util.Collection"%>
<%@ include file="../common/common_include.jsp"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>

<%
	CheckDataForm form = (CheckDataForm)request.getAttribute("command");
%>

<div class="main">
	<div class="oaTable">
	    <div class="toolPannel">
            	<div class="box">
                    <div>
						-年-月-日：
						<input  type="text" style="width:80px;height: 22px;" id="year_month" name="year_month" value="<%=StringUtils.isNotBlank(form.getYear_month())?form.getYear_month():"" %>" onClick="WdatePicker({lang:'zh-cn',dateFmt:'yyyy-MM-dd',maxDate:'%y-%M-%d'})">
					</div>
					<div>所属公司：
						<select id="siteid" class="easyui-combobox" name="siteid" style="width:120px;"></select>
					</div>	
                    <div>

					<input type="button" class="searchSubmit" style="height: 24px;" onclick="javascript:XF.Check.checkSitesReportListSearch()" value="搜索"/>
					<input type="button" class="searchSubmit" style="height: 24px;margin-left: 20px" onclick="javascript:exportExcel('ta')" value="导出"/>
					</div>
				</div>
            </div>
<table id="ta" class="tableList">

	<tbody>
		<tr id="tableHeader">
			<th style="width: 10%">日期</th>
			<th style="width: 20%">分公司</th>
			<th style="width: 10%">总人数</th>
			<th style="width: 10%">应出勤人数</th>
			<th style="width: 10%">请假人数</th>
			<th style="width: 10%">调休人数</th>
			<th style="width: 10%">实考勤人数</th>		
			<th style="width: 10%">考勤率</th>								
		</tr>
		
		<c:forEach var="mymap" items="${list }">
			<tr>
				<td><c:out value="${mymap['kqdate']}" /> </td>																																
				<td><c:out value="${mymap['sitename']}" /></td>	
				<td><c:out value="${mymap['allcount']}" /></td>
				<td><c:out value="${mymap['shouldcount']}" /></td>
				<td><c:out value="${mymap['leavecount']}" /></td>
				<td><c:out value="${mymap['adjustleavecount']}" /></td>
				<td><c:out value="${mymap['realcount']}" /></td>
				<td><c:out value="${mymap['percent']}" /></td>				
			</tr>
		</c:forEach>

	</tbody>
</table>
</div>
</div>
<script>
$('#siteid').combobox({
	url:global.contextPath + '/company/siteList',
	valueField:'siteid',
	textField:'sitename',
    panelHeight: '300'
});
var idTmr;
function  getExplorer() {
    var explorer = window.navigator.userAgent ;
    //ie
    if (explorer.indexOf("MSIE") >= 0) {
        return 'ie';
    }
    //firefox
    else if (explorer.indexOf("Firefox") >= 0) {
        return 'Firefox';
    }
    //Chrome
    else if(explorer.indexOf("Chrome") >= 0){
        return 'Chrome';
    }
    //Opera
    else if(explorer.indexOf("Opera") >= 0){
        return 'Opera';
    }
    //Safari
    else if(explorer.indexOf("Safari") >= 0){
        return 'Safari';
    }
}
function exportExcel(tableid) {
    if(getExplorer()=='ie') {
        var curTbl = document.getElementById(tableid);
        var oXL = new ActiveXObject("Excel.Application");

        //创建AX对象excel
        var oWB = oXL.Workbooks.Add();
        //获取workbook对象
        var xlsheet = oWB.Worksheets(1);
        //激活当前sheet
        var sel = document.body.createTextRange();
        sel.moveToElementText(curTbl);
        //把表格中的内容移到TextRange中
        sel.select;
        //全选TextRange中内容
        sel.execCommand("Copy");
        //复制TextRange中内容
        xlsheet.Paste();
        //粘贴到活动的EXCEL中
        oXL.Visible = true;
        //设置excel可见属性

        try {
            var fname = oXL.Application.GetSaveAsFilename("Excel.xls", "Excel Spreadsheets (*.xls), *.xls");
        } catch (e) {
            print("Nested catch caught " + e);
        } finally {
            oWB.SaveAs(fname);

            oWB.Close(savechanges = false);
            //xls.visible = false;
            oXL.Quit();
            oXL = null;
            //结束excel进程，退出完成
            //window.setInterval("Cleanup();",1);
            idTmr = window.setInterval("Cleanup();", 1);
        }
    } else {
        tableToExcel('ta')
    }
}
function Cleanup() {
    window.clearInterval(idTmr);
    CollectGarbage();
}

var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;base64,',
    template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
    base64 = function(s) {
        return window.btoa(unescape(encodeURIComponent(s)))
    },
    // 下面这段函数作用是：将template中的变量替换为页面内容ctx获取到的值
    format = function(s, c) {
            return s.replace(/{(\w+)}/g,
                            function(m, p) {
                                return c[p];
                            }
            )
    };
    return function(table, name) {
        if (!table.nodeType) {
            table = document.getElementById(table)
        }
        // 获取表单的名字和表单查询的内容
        var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML};
        // format()函数：通过格式操作使任意类型的数据转换成一个字符串
        // base64()：进行编码
        window.location.href = uri + base64(format(template, ctx))
    }
})()
</script>